PROBLEMS THAT OCCURRED DURING THE PROJECT:
1. Created a
function for cleansing data to correct junk string values for names of cities
and places
2. PRINT 'InitCap() function to cleanse source data as below:
PRINT 'new-yORK ==> ' + dbo.InitCap('new-yORK')
PRINT 'new/york ==> ' + dbo.InitCap('new/york')
PRINT 'new yORK ==> ' + dbo.InitCap('new yORK')
PRINT 'quad cities, ia/il ==> ' + dbo.InitCap('quad cities, ia/il')
3. InitCap() function to cleanse source data as below:
new-yORK ==> New-York
new/york ==> New/York
new yORK ==> New York
quad cities, ia/il ==> Quad Cities, Ia/Il
http://blog.decisivedata.net/blog/cleaning-messy-data-sql-part-3-sql-functions-clean-strings
Cleaning Messy Data in SQL, Part 3: SQL Functions to Clean Strings